package com.system.dao;

import com.system.pojo.EmployeeDimission;

import java.util.List;
import java.util.Map;

/**
 * Created by 陈文杰 on 2022/6/6 14:58
 */
public interface EmployeeDimissionMapper {

    //查询所有离职员工
    List<EmployeeDimission> queryEmployeeDimissionAll();

    //根据主键id查询离职员工信息
    EmployeeDimission queryEmployeeDimissionByEmpDimId(int empDimId);

    //根据离职员工id查询离职员工信息
    EmployeeDimission queryEmployeeDimissionByEmpId(int empId);

    //根据离职员工姓名查询离职员工信息
    EmployeeDimission queryEmployeeDimissionByEmpName(String empName);

    //根据离职员工部门查询离职员工信息
    List<EmployeeDimission> queryEmployeeDimissionByEmpDimDeptName(String empDimDeptName);

    //根据离职员工岗位查询离职员工信息
    List<EmployeeDimission> queryEmployeeDimissionByEmpPost(String empPost);

    //根据离职时间岗位查询离职员工信息
    List<EmployeeDimission> queryEmployeeDimissionByEmpDimDate(String empDimDate);

    //根据离职时间区间岗位查询离职员工信息
    List<EmployeeDimission> queryEmployeeDimissionByEmpDimDateSection(String empDimDate1,String empDimDate2);

    //添加员工离职信息
    int addEmployeeDimission(EmployeeDimission employeeDimission);

    //根据主键id修改离职员工信息
    int updateEmployeeDimissionByEmpDimId(Map<String,Object> map);

    //根据离职员工id修改离职员工信息
    int updateEmployeeDimissionByEmpId(Map<String,Object> map);

    //根据离职员工姓名修改离职员工信息
    int updateEmployeeDimissionByEmpName(Map<String,Object> map);

    //根据主键id删除离职员工信息
    int deleteEmployeeDimissionByEmpDimId(int empDimId);

    //根据离职员工id删除离职员工信息
    int deleteEmployeeDimissionByEmpId(int empId);

    //根据离职员工姓名删除离职员工信息
    int deleteEmployeeDimissionByEmpName(String empName);

    //根据离职员工部门删除离职员工信息
    int deleteEmployeeDimissionByEmpDimDeptName(String empDimDeptName);

    //根据离职员工岗位删除离职员工信息
    int deleteEmployeeDimissionByEmpPost(String empPost);

    //根据离职时间岗位删除离职员工信息
    int deleteEmployeeDimissionByEmpDimDate(String empDimDate);

    //根据离职时间区间岗位删除离职员工信息
    int deleteEmployeeDimissionByEmpDimDateSection(String empDimDate1,String empDimDate2);

}
